USE GD2C2014

DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].ConsumiblexEstadia;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].Consumible;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].Estadia;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].HabitacionxReserva
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].ReservaCancelada;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].Reserva;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].RenglonFactura;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].Factura;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].RegimenxHotel;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].Regimen;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].Habitacion;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].TipoDeHabitacion;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].Baja_Hotel;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].UsuarioxHotel;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].RolxUsuario;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].Usuario;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].Cliente;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].Hotel;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].Persona;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].RolxFuncionalidad;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].Funcionalidad;
DROP TABLE [WE_MISS_THE_GARBAGE_COLLECTOR].Rol;
DROP FUNCTION [WE_MISS_THE_GARBAGE_COLLECTOR].cantidadPersonas;
DROP FUNCTION [WE_MISS_THE_GARBAGE_COLLECTOR].DameDireccion;
DROP FUNCTION [WE_MISS_THE_GARBAGE_COLLECTOR].DevolvemeTipoDeDocumento;
DROP PROCEDURE [WE_MISS_THE_GARBAGE_COLLECTOR].[Login];
DROP PROCEDURE [WE_MISS_THE_GARBAGE_COLLECTOR].SP_BajaCliente
DROP PROCEDURE [WE_MISS_THE_GARBAGE_COLLECTOR].SP_ModificacionCliente
DROP PROCEDURE [WE_MISS_THE_GARBAGE_COLLECTOR].SP_insert_rolxusuario
DROP PROCEDURE [WE_MISS_THE_GARBAGE_COLLECTOR].SP_insert_usuarioxhotel
DROP PROCEDURE [WE_MISS_THE_GARBAGE_COLLECTOR].SP_modificacion_usuario
DROP PROCEDURE [WE_MISS_THE_GARBAGE_COLLECTOR].SP_Disponibilidad_Pedido
DROP PROCEDURE [WE_MISS_THE_GARBAGE_COLLECTOR].SP_Obtener_Cant_Personas
DROP PROCEDURE [WE_MISS_THE_GARBAGE_COLLECTOR].SP_Obtener_Tipo_Porcentual
DROP PROCEDURE [WE_MISS_THE_GARBAGE_COLLECTOR].SP_Ultimo_ID_Reserva
DROP PROCEDURE [WE_MISS_THE_GARBAGE_COLLECTOR].SP_Generar_Reserva_Por_Usuario
DROP PROCEDURE [WE_MISS_THE_GARBAGE_COLLECTOR].SP_Generar_Reserva_Por_Cliente
DROP PROCEDURE [WE_MISS_THE_GARBAGE_COLLECTOR].SP_Cancelar_Reserva
DROP SCHEMA [WE_MISS_THE_GARBAGE_COLLECTOR]
GO